class CreateSiteHeartBeatDailyStats < ActiveRecord::Migration
  def self.up
    create_table :site_heart_beat_daily_stats do |t|
      t.integer :site_health_setting_id
      t.integer :available_site_heart_beats_count, :default => 0
      t.integer :unavailable_site_heart_beats_count, :default => 0
      t.integer :response_time, :default => 0
      t.integer :the_fastest_heart_beat_id,
        :the_slowest_heart_beat_id
      t.date :created_on        
      t.timestamps
    end
  end

  def self.down
    drop_table :site_heart_beat_daily_stats
  end
end
